G/L Primary Post Payroll

This window establishes the rules for generating posting transactions based on payroll transactions that form the components of employee's pays. The relevant General Ledger Debit and Credit account numbers are assigned.

Prerequisites

Rules and Guidelines

  • Separate rules for the group PAYG tax paid can be defined. The Group Tax can be posted to the appropriate General Ledger accounts.
  • A separate record for each Costing Location can be established or use Substitution Expressions to cover several costing locations. Some expenses may be costed on a state by state level within each company, and other expenses by business units within each state and company.
  • Any existing Primary Post records can be viewed and maintained.
  • Each type of record is identified by an H Hours Types or an A Allowance/Deduction or an L Leave Liability movement.

  • If the Retrospective Pay field is blank, then the retro transactions from payroll will be posted to the G/L in the same manner (same G/L Debit and G/L Credit Accounts) as the other non-retro transactions that each rule is calculating.

    If the Retrospective Pay field is ticked, then only retro transactions from payroll will be posted to the G/L, and all other transactions that meet the other criteria within this rule will display as an ERROR to indicate that they cannot be processed. For every G/L posting rule that there is a record with the flag ticked, there also needs to be a record with the flag not ticked to ensure that non-retro transactions can be posted.

    Thus, if the Retrospective Pay field is blank, the rule will process for both retro and non-retro transactions from payroll. It is only if the retro transactions need to be processed to different G/L accounts that separate rules need to be created for retro (ticked) and non-retro (unticked) transactions.

Field Information

Specify how the posting transactions will be generated.

Option Description
A Allowance/Deduction Code
H Hours Type Code
L Leave
N Net Pay

Records with a Code of L are not included in the accrual/reversal process.

Select the code based on the Type selected in the Hours, A/D, or Leave field.

If this field is left blank, those Hours Types, Allowances/Deductions or Leave Classifications not already covered in another specific record are covered in this record.

Select the company.

Select the state.

Select the applicable location.

Select the wage group from the list.

Select the appropriate cost centre.

Enter a valid Costing Account Number if required.

Enter a valid Department Number if required.

Enter a valid Employment Type if required.

Enter a valid Personnel Type if required.

Select the Costing Method to be included in the posting to this General Ledger Account Number.

Option Description
A Records defined as Actual Costs
S Records defined as Standard Costs

 

The Costing Type to be included in the posting of this General Ledger Account Number.

Option Description
D Departmental Costing. Select records that do not have Labour Cost codes attached, but do have Department/Account codes.
L Labour Costing. Select records that do have labour cost codes attached, regardless of whether or not they have Department/Account codes.

 

The Payment Method to be included in the posting to the General Ledger.

Option Description
B Bank Credit
C Cheque
D Express Pay Bank Credit
E Envelope/(Cash)
F Express Pay Cheque
G Express Pay Cash
H Express Pay No Payment
M Express Payment
N No Payment
P Prepayment
R Rebank

 

This field allows a rule to be created to direct portions of an A/D code to specific General Ledger Accounts. The functionality associated with the use of the "Include in Costing" 'H' and 'L' options for A/D codes. If enabled, the value of an A/D code will be broken down into 'portions' that are associated with the Classification Code for any HOURS codes paid in the period, and the Associated Hours Classification can be used to create separate General Ledger rules for each portion.

The different Hours Classifications supported are:

Options Description
A Annual Leave Loading
L Long Service Leave
N Normal Pay
O Other Leave
P Public Holiday
Q Training
R RDO
S Sick Leave
T Overtime
V Annual Leave
W Workers Compensation

Note: This field will only be active when the Payroll Code type is 'A/D'.

 

This field displays the following options:

Option Description

Blank

Any transactions flagged as Retro Pay will be posted to the same G/L account as non-retro pay.

Note: This field is blank by default.

Ticked

Any transactions flagged as Retro Pay will be posted to the G/L accounts listed on the window where it is ticked.

Any non-retro records will be ignored by this rule if ticked.

Note that this field is activated when either Hours (H) or A/D (A) is selected in the Hours, A/D, or Leave field.

A General Ledger debit account number or the components that make up a General Ledger account number using Substitution Expressions.

A General Ledger credit account number or the components that make up a General Ledger account number using Substitution Expressions.

A General Ledger accrual debit account number or the components that make up a General Ledger account number using Substitution Expressions.

  • This field is not available if the Oncost is for a Leave record
  • This field is activated if the Program Control option GLACC has been activated to run using Accruals Method #1 G/L Update Period.

 

A General Ledger accrual credit account number or the components that make up a General Ledger account number using Substitution Expressions.

  • This field is not available if the Oncost is for a Leave record.
  • This field is activated if the Program Control option GLACC has been activated to run using Accruals Method #1 G/L Update Period.

 

Each posting transaction generated using the posting rules is allocated the Journal Number entered in this field.

  • It represents a collection of self balancing transactions for reporting purposes.

 

This field is displayed only if Program Control option STATS has been setup and is only valid for the Interface to JDE Release 7 - Product Code 22.

Option Description
A Create a statistical record AND a normal record.
N Create a normal record, NO statistical record.
O Create a statistical record only, No normal record.

 

Oncosts

This field relates to the Payroll Tax Percent Record.

Specify if the relevant payroll transactions will be included in the calculation of the Payroll Tax or not.

Option Description
Y

Payroll transactions applicable to the defined rules are included in the calculation of payroll tax.

If this value is selected, a corresponding Payroll Tax Posting Table record for the same costing centre must be setup to create a corresponding Payroll Tax Posting Table for the same Costing Centre.
N Payroll transactions applicable to define rules are not included in the calculation of Payroll Tax oncosts.

 

This field relates to the Workers Compensation oncosts. Specify if the relevant payroll transactions will be included in the calculation of the Workers Compensation oncosts.

Option Description
Y

Payroll transactions applicable to the defined rules are included in the calculation of Worker's Compensation oncosts.

If this value is selected, the corresponding Workers Compensation Oncosts Posting Table records for the same costing centre need to be setup.
N Payroll transactions applicable to the defined rules are not included in the calculation of Worker's Compensation oncosts.

 

This field relates to Annual Leave oncosts.

Specify if the relevant payroll transactions will be included in the calculation of the Annual leave oncosts.

Option Description
Y

Payroll transactions applicable to the defined rules are included in the calculation of Annual Leave oncosts.

If this value is selected, the corresponding Annual Leave Oncosts Posting Table records for the same costing centre need to be setup.
N Payroll transactions applicable to the defined rules are not included in the calculation of Annual Leave oncosts.

 

This field relates to Long Service Leave oncosts.

Specify if the relevant payroll transactions will be included in the calculation of the Long Service leave oncosts.

Option Description
Y

Payroll transactions applicable to the defined rules are included in the calculation of Long Service Leave oncosts.

If this value is selected, the corresponding Long Service Leave Oncosts Posting Table records for the same costing centre need to be setup.
N Payroll transactions applicable to the defined rules are not included in the calculation of Long Service Leave oncosts.

 

This field relates to General Oncosts.

Specify if the relevant payroll transactions will be included in the calculation of General oncosts.

Option Description
Y

Payroll transactions applicable to the defined rules are included in the calculation of oncosts.

If this value is selected, the corresponding General Oncosts Posting Table records for the same costing centre need to be setup.
N Payroll transactions applicable to the defined rules are not included in the calculation of oncosts.

 

Each posting transaction generated using the posting rules is allocated the journal number entered in this field. It represents a collection of self balancing transactions for reporting purposes.

The Open Period File report and the Closed Period File report are both sequenced by journal number.